What are limitations of joiner transformation?
Answer Posted / seshagiri k
1.Both the pipelines begin with the same original data spouece
2.Both input pipelines originate from the SQ transformation
3.Both input pipelines originate from the same normalizer t/r
4.Either input pipelines contains an update transformation
5.Either input pipelines contains a connected or unconnected
sequence generator transformation
| Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
What the difference is between a database, a data warehouse and a data mart?
Mention few advantages of router transformation over filter transformation.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Please let me know how to make encryption and decryption with example?
What are the prerequisite tasks to achieve the session partition?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
In how many ways we can create ports?
What are the mapping parameters and mapping variables?
What is option by which we can run all the sessions in a batch simultaneously?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the need for an etl tool?
What are mapplets?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Partition, what happens if the specified key range is shorter and longer