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
- 37684 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / srikanth reddy m
A.Use column generator stage for each of second and third tables for to generate extra columns as that of first table for to generate mock data and then use funnel stage finally to capture data from three tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
which r the connectors used in san?
What are the different type of jobs in datastage?
What are the types of containers and how to create them?
How many types of stage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is active and passive stage?
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
What are the functionalities of link partitioner and link collector?
Define APT_CONFIG in Datastage?
sed,awk,head
What is the difference between orabulk and bcp stages?
What is the purpose of pivot stage and types of containers in datastage
What is the difference between hashfile and sequential file?
Define oconv () and iconv () functions in datastage?
Describe the main features of datastage?
