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
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|
how many types of remove the duplicate records?
difference between server shared container and parallel shared container
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
What are operators in datastage?
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
What is the difference between validated and compiled in the datastage?
How do u set a default value to a column if the column value is NULL?
What is the difference between server job and parallel jobs?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
Explain the scenarios where sequential file stage runs in parallel?