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 |
Hi This is Vijay, How can your remove the duplicates in sequential File?
15 Answers HCL, Scope International,
What is container and then types?
Differentiate between operational datastage (ods) and data warehouse?
What are the important features of datastage?
What is the difference between informatica and datastage?
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.
How to display all the duplicate records from the oracle Table?
what is usage of datastage with materialized views
what is the unix script to run the job? Please mention commands which we use often?
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
Why we use surrogate key?
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?