Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 5604 Views
- Amdocs, I also Faced
- E-Mail Answers
my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?
which unix commands mostly used in datastage
What is a merge?
Two source files contains same meta data third file contains different data types can I funnel that file.
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?
HOW CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
Explain the datastage parallel extender (px) or enterprise edition (ee)?
what is set mapping in datastage??
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
what is a message handler
detail about sdlc
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
Teradata 
