ETL Interview Questions
Questions Answers Views Company eMail

Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

1807

What is Data Vault???

2339

What is factless fact schema?

3 5993

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1371

where we cannot use sorter Transformation. if we use then we will not get correct data?

1801

we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??

1 4725

we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??

4 7249

I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 4825

WHY CANT WE SEE THE DATA IN DATASET

IBM,

1 4982

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

1730

what are the types in error loging?

Cap Gemini,

1633

IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.

TCS,

3 12366

how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com

TCS,

2 16853

flat filevalidation in informatica

Hewitt,

1742

how to connect to a flatfile through ftp in informatica

TCS,

1 13439


Post New ETL Questions

Un-Answered Questions { ETL }

How to delete data which is not in source table?

832


Explain what is etl process? How many steps etl contains explain with example?

504


A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

1824


what is Forward,Reverse and Re_engineering?

1726


What are the types of Data Warehouse applications?

514






list and discuss two approaches for updation of target table in Informatica and how they are different.

1729


Define Dynamic push down optmization?

1909


Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1634


can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1305


how many maximum session supports to multiload in teradata ??

1694


Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

1717


what are the data modeling tools you have used?(polaris)

1545


Do we need an etl tool?

556


What is the difference between Data Warehousing and Data Mining?

543


Explain about hash partitioning?

539