I/P
---
ID Value
1 AB
2 ABC
3 ADE
4 A
O/p
---
ID Value
1 A
1 B
2 A
2 B
2 C
3 A
3 D
3 E
4 A
Post New Answer View All Answers
What is the use of datastage designer?
Give an idea of system variables.
How a source file is populated?
How to read the length of word in unix?
In Datastage, how you can fix the truncated data error?
What is process model?
Enlist various types of routines in datastage.
Define APT_CONFIG in Datastage?
What is the difference between odbc and drs stage?
Define data aggregation?
Differentiate between odbc and drs stage?
How many types of stage?
What is a folder? Difference types of stages?
How do you import and export the datastage jobs?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.