ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Data Stage
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
how do u capture duplicates through sort & transformer
 Question Submitted By :: Raam
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how do u capture duplicates through sort & transformer
Answer
# 1
Hai..,

In sort stage we have one property...its create key change 
column.

In Transformer stage ,we have to write if then else 
condition.....
 
Is This Answer Correct ?    0 Yes 0 No
Kiran
 

 
 
 
Other Data Stage Interview Questions
 
  Question Asked @ Answers
 
what about data stage requirement  1
Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok Accenture1
How do u view log file for a particular job? HP3
what is sparse lookup?  5
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how? UHG2
Hi This is Vijay How Can u Read the data from sequential file Parall'y? Semantic-Space3
Hi Vijay here For Four CPU's how many nodes will required? TCS2
how can we extract data with out having any common column IBM5
what r the stages mostly used in realtime scenarios IBM1
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? Wipro2
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query. TCS2
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...  2
HOW TO CREATE ENVIRONMENTS AND CALL THEM?WHAT IS THE USE DEFINED VARIABELS? ME1
HOW TO INTILIAZE ENVIRONMENT VARIABELS? & WHERE YOU WILL GIVE VALUES FOR THESE VARIABELS?(I MEAN FOR PARAMETERS WE WILL GIVE VALUES BEFORE RUNNING IN RUN WINDOW,THEN WHERE YOU WIL GIVE VALUES TO E.VARAIABELS?) Infosys2
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table? TCS1
tell me abt Datastage trigger? HP1
HOW CAN WE SEE THE DATA IN DATASET? IBM2
can we use sequential file as a lookup Wipro4
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT? GE2
What's the Main Function of the Staging area in DWH Oracle1
 
For more Data Stage Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com