Source contains the metadata
source
-----
hyderabad,chennai,bangalore by using nested loop sequence
select source as hyderabad in target just run target as
hyderabad only not others please give me answer thanks in
advance(give reply how to wrote logic using nested loop
sequence)
how to identifie,is it innerjoin,leftouter join in lookup?
What are the main differences you have observed between 7.x and 8.x version of datastage?
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 is exact difference between Parallel Jobs and server Jobs..
wt is the diff b/w odbc and oracle stage
what is the use of invokation id
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
how can u find out the datastage job is running on how many nodes
What are the types of containers?
Define ds designer?
tell me abt Datastage trigger?
What is merge stage?