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 / prasu
Put the transformer before the 2 tables which u have
lesscolumns.
and then add the remaning columns for the 2 tables.then
join with funnel stage
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Define Job control?
Explain the situation where you have applied SCD in your project?
In Datastage, how you can fix the truncated data error?
project Steps,hits, Project level HArd things,Solved methods?
Demonstrate experience in maintaining quality process standards?
What is difference between symmetric multiprocessing and massive parallel processing?
what is the use of surogate key in datastage
what are the errors,warnings in datastage
Is possible to create skid in dim,fact tables?
Give an idea of system variables.
What are the repository tables in datastage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Differentiate between validated and Compiled in the Datastage?
what is the use of skid in reporting?
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