Two source files contains same meta data third file
contains different data types can I funnel that file.
Answers were Sorted based on User's Feedback
Answer / karimulla
Hello Friend,
In funnel stage the input metadata should be same.so it will
not work in funnel stage.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ranjan
First we shouldnt do this. But still if you want to do then
we can take a transformer before funnel change the
datattype and conversion functions then funnel it and then
again take a transformer and change it to original datatype
and conversion.
| Is This Answer Correct ? | 0 Yes | 5 No |
What are the types of containers?
How many areas for files does datastage have?
What is data partitioning?
Define Job control?
what are fact tables and dimension tables? give example assuming one table.
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
What is the purpose of interprocessor stage in server jobs?
What is PX?
What is datastage?
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD