Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17 Answers
- 42646 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / raji
Just keep one transformer stage before funnel stage.Three
links(from three tables) should be coming as input for this
transformer. For the first link add the other tables
columns and so on.Make all the links have same number of
output columns. It should have same metadata definitions. i
mean these three links should contain all the 9 columns or
whatever it is.Now you can proceed further.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
Can we use target hash file as a lookup ?
What is size of a transaction and an array means in a datastage?
How will you move hashed file from one location to another location?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
I have a few records just I want to store data in to targets cycling way how?
how to delete one row in target dataset
What is orabulk stage?
What is the purpose of pivot stage and types of containers in datastage
Define Data Stage?
What is process model?
What are the types of views in datastage director?
To see hidden files in LINIX?
What are the different plug-ins stages used in your projects?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
