What is mapping?
Answers were Sorted based on User's Feedback
Answer / vijay
don't more explanation...just it is ALIGNING SOUCE COLUMNS
TO TARGET COLUMNS WITH OR WIHOUT USING STAGE.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / maruthi
MAPPING.)IN INFORMATICA MAPPING IS REFERRED AS A COLLECTION
TRANSFORMATION AND CONNECTING THEM.
IN DATAS TAGE WE WILL CALL THE SAME MAPPING AS JOB
JOB IS A COLLECTION OF STATGS LINKED TOGETHER.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ramjanaki
I think you are referring to the Mapping of Columns in the
Transformer Stage.
It is nothing but relating the columns from the source
stage to the target in the Transformer stage by drag and
drop. Transformations like for example, doing some
condition check, applying some functions etc., can be done
here and the resultant data will be loaded to the target.
| Is This Answer Correct ? | 1 Yes | 1 No |
What are the functionalities of link collector?
Two source files contains same meta data third file contains different data types can I funnel that file.
Is the value of staging variable stored temporarily or permanently?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
What are the different plug-ins stages used in your projects?
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
I have a few records just I want to store each records tow times in target how?
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
how to closeing records after 10,000 records come?
on how many columns we can perform aggregation in the aggregator stage?