Informatica and Boxi for Dummies

How can we do this: StudentName Subject1 Marks1 Subject2 Marks2 Sam Maths 100 English 80 John Maths 85 English 75 to the target: Stu...

Please comment if you like the video

Please comment if you like the video.. Thanks!!!

Input : Student Name Subject Name Marks Srivatsan Maths 100 Sendil Maths 95 Ragu Physical Science 96 Muthu Maths 75 Uma Life Scienc...

Input : Student Name Maths Life Science Physical Science Sam 100 70 80 John 75 100 85 Tom 80 100 85 Output : Student Name Sub...

CREATE OR REPLACE PROCEDURE EXAMPLE_PROC IS CURSOR EMP_CUR IS SELECT * FROM EMP; EMP_REC EMP_CUR%ROWTYPE; BEGIN OPEN EMP_CUR; LOOP FETCH EM...

DECLARE CURSOR EMP_CUR IS SELECT * FROM EMP; EMP_REC EMP_CUR%ROWTYPE; BEGIN OPEN EMP_CUR; LOOP FETCH EMP_CUR INTO EMP_REC; EXIT WHEN EMP_CU...

DECLARE                     -- Declaration section v_ename emp.ename%type ; BEGIN                        -- Execution section Select en...

Connected Lookup : 1) Connected Lookup can return more than one value.The number of Output port can be more than one. 2) The Cache will...

Source Qualifier Transformation is an active Transformation. The reason is the output rows count can be modified by using option like ...

In informatica level the aggregator transformations output can be obtained by replacing it with the following transformations 1) Sorter ...

Whenever we have only one Source Qualifier transformation and multiple targets , our approach in specifying the order of the target is by u...

Target Load plan is used to load the targets in whichever order we require . Target Load plan can be used when the mapping has more than ...

Input : Student Name Subject Name Marks Sam Maths 100 Tom Maths 80 Sam Physical Science 80 John Maths 75 Sam Life Science 70 John ...

Joining Heterogeneous Sources can't be done using the Source Qualifier Transformation . Source Qualifier transformation is used to jo...