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
- 44062 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
What are the enhancements made in datastage 7.5 compare with 7.0?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Is it possible to query a hash file?
What is data partitioning?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the difference between operational data stage (ods) and data warehouse?
Could anyone give brief explanation bout datastage admin
What are the functionalities of link partitioner?
What all the types of jobs you developed?
explain about citrix scheduling tool in datastage
What is the difference between datastage and informatica?
What is staging variable?
What is the difference between validated and compiled in the datastage?
Have you used Unstructured data?
What are stage variables?
