my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?
Answer Posted / varaprasad
as for as i know,it is simple task only,
order is seq_file->column_generator->tfx->connect 4 targets.
in CG take one more column as SNO(anything)and goto extended column properties- take value=1,value=2,,,upto 4. now write constraint in tfx sno=1 goto t1
sno=2 goto t2...for all targets(4).
if u get other tahn this pls post answer
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
What are system variables and sequencers in datastage
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
what is the difference between == and eq in UNIX shell scripting?
what are the devoleper roles in real time? plz tell i am new to datastage....
how to sort two columns in single job in datastage.
Explain entity, attribute and relationship in datastage?
Name the different types of Lookups in Datastage?
Can you highlight the main features of ibm infosphere information server?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How we can covert server job to a parallel job?
Explain the importance of surrogate key in data warehousing?
State the difference between an operational datastage and a data warehouse?
What is the difference between validated and compiled in the datastage?
On which interface you will be working as a developer?