Informatica Interview Questions
Questions Answers Views Company eMail

How to load last 10 records of flat file in to the target?

iNautix,

5 23434

how can we calculate fact table size?

1 5722

how i will stop my workflow after 10 errors

HP,

2 6251

why we r using presql&postsql in source qualifier?

HP,

1 5527

how i will stop my workflow after 10 errors

HP,

1 6369

I have source like this 1:2;3. so i want to load the target as 123

HP,

4 6458

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

HP,

3 4964

what is size of u r database?

1931

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

Oracle,

2 5159

what is the size of ur database(like oracle)

HP,

2 5287

what is the size of u r project? and what is the size of source file?

HP,

1 5347

what is the size of u r source(like file or table)?

HP,

1901

my source is junk data how will u remove that junk data by using unix please any one replay me

Cap Gemini,

3335

how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

Cap Gemini, IBM,

16 21886

explan ur project architecture?

TCS,

1685


Post New Informatica Questions

Un-Answered Questions { Informatica }

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1989


How to generate or load values in to the target table based on a column value using informatica etl tool.

692


What is an unconnected transformation?

748


can we override a native sql query within informatica? How do we do it?

728


What is informatica worklet?

690






What is the difference between router and filter?

710


What is aggregate cache in aggregator transformation?

697


What are the types of schemas we have in data warehouse.

608


What is the way to execute pl/sql script using informatica mapping?

1065


How does the aggregator transformation handle null values?

785


Informatica settings are available in which file?

667


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4386


What is an expression transformation?

687


Slowly changing dimensions, types and where will you use them

1342


According to his methodology what all you need before you build a datawarehouse

1277