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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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
if 3 table having different columes. like first table 
having 4 columns , second table having 3 columns and third 
table having 2 columns then how to capture the data by 
using funnel stage in parallel jobs...srinu.thadi
 Question Submitted By :: Vyas_parallel
I also faced this Question!!     Rank Answer Posted By  
 
  Re: if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
Answer
# 1
As:1
 Frist you find common columen from the 3 table then you 
can use funnel stage 
 in funnel stage set the properte KEY= COOMON COLUMEN
                       
                            Chowdary
 
Is This Answer Correct ?    1 Yes 4 No
Chowdary
 
  Re: if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
Answer
# 2
plz explain in detail
 
Is This Answer Correct ?    0 Yes 0 No
Pspkr
 
 
 
  Re: if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
Answer
# 3
to combined the data from 3 different files in funnel (same
meta data require )
 
Is This Answer Correct ?    0 Yes 0 No
Rajesh
 
  Re: if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
Answer
# 4
haa.....Chowdary


if you don't know answer ,please  don't give wrong answers.

i have given answer  is wrong....
 
Is This Answer Correct ?    1 Yes 0 No
Anitha
 
  Re: if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
Answer
# 5
If you want combine 3tables with different column name.
First use modify stage between source and funnel stage. 
change the cloumns name in the 3tables into standard format.

or

you can try with transformer for creating new column name 
for each table.

mailme if you have queries.
samala.madhu@gmail.com
 
Is This Answer Correct ?    0 Yes 0 No
Madhusudhan
 
  Re: if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
Answer
# 6
You can achive this by using Column Import,Funnel and 
Column Export stages.

Thanks

Sumit
 
Is This Answer Correct ?    0 Yes 0 No
Sumit
 
  Re: if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
Answer
# 7
Just keep one transformer stage before funnel stage.Three 
links(from three tables) should be coming as input for this 
transformer. For the first link add the other tables 
columns and so on.Make all the links have same number of 
output columns. It should have same metadata definitions. i 
mean these three links should contain all the 9 columns or 
whatever it is.Now you can proceed further.
 
Is This Answer Correct ?    1 Yes 1 No
Raji
 
  Re: if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
Answer
# 8
rajii in parallel jobs Transformer accepts only one input link
so u ranswer is wrong
think
 
Is This Answer Correct ?    0 Yes 0 No
Sag
 

 
 
 
Other Data Stage Interview Questions
 
  Question Asked @ Answers
 
what is meta data? Explain? Where it is used?  7
How do u view log file for a particular job? HP2
What are the different database update actions available? HP1
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD L&T2
what is the main differences between Lookup, Join and Merge stages?  4
Wat is pre-load in Hashed file Patni1
tell me abt Datastage trigger? HP1
What modeling tool do you use? HP5
what is the diff between sequential file and fileset stages?  2
What is lookup table?  3
What is exact difference between Parallel Jobs and server Jobs.. IBM4
what is the difference between datasatge and datastage TX?  5
how can we extract data with out having any common column IBM1
Why we need datasets ratherthan sequential files?  4
what is the differeces between hash and modulus partition methods  1
How did you reconcile source with target? HP2
What are the environmental settings for data stage,while working on parellel jobs? Satyam1
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER? Wipro2
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY? L&T1
How can we run same job in 1 day 2 times IBM2
 
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