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
- 44032 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / kalyanreddy
Hi Vyas,
Please ask the question properly....
Other wise you wont get right ans...
There are two posibilities
1.
table 1 has 4 col..
like
a,b,c,d
table 2 has 3 col..
like
a,b,c
table 3 has 2 col..
a,b
In this case funnel stage give only two output columns
(consider same metadata)
which are common in all the table ( in funnel stage no
properties are there for selecting common columns from
input).
2.
If Metadata is not same in above table change metadata in
transformer stage before using funnel based on requirement
only and consider datatypes of the columns.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Can you explain kafka connector?
Could anyone give brief explanation bout datastage admin
what is the difference between == and eq in UNIX shell scripting?
how to implement scd2 in datastage 7.5 with lookup stage
What are stage variables and constants?
client know skid info?
Differentiate between hash file and sequential file?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is the purpose of pivot stage and types of containers in datastage
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is the process of killing a job in datastage?
Differentiate between data file and descriptor file?
What is a datastage job?
What are the different options associated with dsjob command?
What is aggtorec restructure operator?
