if 3 table having different columes. like first table
having 4 columns , second table having 3 columns and third
table having 2 columns then how to capture the data by
using funnel stage in parallel jobs...srinu.thadi
Answer Posted / chowdary
As:1
Frist you find common columen from the 3 table then you
can use funnel stage
in funnel stage set the properte KEY= COOMON COLUMEN
Chowdary
| Is This Answer Correct ? | 3 Yes | 19 No |
Post New Answer View All Answers
How a source file is populated?
What is the difference between hashfile and sequential file?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How can we improve performance of data stage jobs?
What can we do with datastage director?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the process of killing a job in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How and where you used hash file?
What is data partitioning?
Explain ibm infosphere information server and highlight its main features?
Define APT_CONFIG in Datastage?
How to clean the datastage repository?
what is 'reconsideration error' and how can i respond to this error and how to debug this
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? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?