What is the difference between informatica and datastage?
No Answer is Posted For this Question
Be the First to Post Answer
how can you generate sequence number using only the sequential file stage?
When we will go for Data elements?
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?
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
What is the default padding character?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How do you load 10 different sources with 10 different layouts to 10 different tables?
what is the difference between the active datawarehouse and datawarehouse
how can find maximum salary by using Remove duplicate stage?
Two source files contains same meta data third file contains different data types can I funnel that file.
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?