How many input links can you give to a Transformer stage?
Answers were Sorted based on User's Feedback
Answer / raghava naidu.k
It has one input link, many outputs & a rejected link
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / sai
In Parallel jobs,Transformer can have one input
link ,multiple output links and single reject link.
But in Server jobs,Transformer can have one input
link ,multiple reference links,multiple output links and
single reject link.
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / srinivas
It will allow one input and one reference link...
| Is This Answer Correct ? | 1 Yes | 5 No |
how do u reduce warnings
in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?
What are the areas of application?
Name the third party tools that can be used in datastage?
What is the difference between orabulk and bcp stages?
is it possible to access the same job by two users at a time in DataStage?
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
In one project how many shared containers are created?
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
Demonstrate experience in maintaining quality process standards?