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???

2334

What is factless fact schema?

3 5973

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

1365

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

1797

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 4717

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 7239

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 4814

WHY CANT WE SEE THE DATA IN DATASET

IBM,

1 4970

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

1727

what are the types in error loging?

Cap Gemini,

1627

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 12349

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 16835

flat filevalidation in informatica

Hewitt,

1737

how to connect to a flatfile through ftp in informatica

TCS,

1 13431


Post New ETL Questions

Un-Answered Questions { ETL }

Two default user groups created in the repository are____and_____.

1643


What is etl process. How many steps etl contains explain with example?

511


What is partitioning? Explain about round-robin, hash partitioning.

543


how do u handle performance issues in Informatica . where can u monitor the performance ?

4261


explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

3611






Can there be sub steps of etl steps?

527


dimension object created in oracle can be imported in designer?how?

2450


Can u access a repository created in previous version of Informatica?

1462


Give the benefits of data integration suite?

489


Compare etl & elt?

545


how do u set partition points in the mapping?

2092


what is the main role of FI on business

1621


how do u extract data from different data sources explain with an example?

1772


Can we create Hierarchies in generic datasources?

1920


What is virtual Data Warehousing?

543