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   SiteMap shows list of All Categories in this site.
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
wt is the difference between swith and filter stage
 Question Submitted By :: Muralipmsc
I also faced this Question!!     Rank Answer Posted By  
 
  Re: wt is the difference between swith and filter stage
Answer
# 1
Hi,

The main diff between filter and switch stages..
filter performs on sql queries and we can declare 'n' num 
of out puts for 'n' num of where clause conditions.
But in swith stage perfoms on single column level rows 
only.. and every time it checks source system befor going 
to load the data into target, but filter not like that.

If you have any doubt in this.... give a cal to my num..

Swamy - 9985223203
 
Is This Answer Correct ?    0 Yes 2 No
Swamy
 
  Re: wt is the difference between swith and filter stage
Answer
# 2
Hai Swamy..,

How are You?

Your Ans is wrong boss.

In filter Stage  we can give multiple conditions on 
multiple columns,But every time data come from source 
system and filtered data loads into target .where as in 
switch stage we can give Multiple conditions on Single 
column,but data come only once from the source and checks 
all the conditions in the switch stage and loads in to 
target.

Please correct ur ans.
Thank u
 
Is This Answer Correct ?    1 Yes 1 No
Kiran
 
 
 

 
 
 
Other Data Stage Interview Questions
 
  Question Asked @ Answers
 
In merge stage can we update the values? TCS1
what r the stages mostly used in realtime scenarios IBM1
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha CTS1
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 Wipro1
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?  1
How do u set a default value to a column if the column value is NULL? HP5
what is Audit table?Have u use audit table in ur project? Wipro1
When we will go for Data elements? TCS3
how to call routines in stages? ME2
What modeling tool do you use? HP5
detail about sdlc  3
why we use hash file for lookup?  1
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically TCS5
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how? UHG2
With out using Funnel Stage, how to populate the data from different sources to single target  8
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 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
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?  1
What are the environmental settings for data stage,while working on parellel jobs? Satyam2
what is the difference between datasatge and datastage TX?  6
 
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