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 |
ename like ibm,tcs,hcl need display those records only how?
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
Difference between data warehousing and olap?
Where do you see different stages in the designer?
Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
What is difference between symmetric multiprocessing and massive parallel processing?
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
What is staging variable?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
What is the flow of loading data into fact & dimensional tables?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)