Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 1899

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1043

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

TCS,

1 2265

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

TCS,

2 2460

explain different levels in pushdown optimization with example?

TCS,

2 5394

waht type of interface is used for testing the data in informatica

CTS, TCS,

1332

wat are deployement groups in informatica, how it will be used for developers

844

what is the difference between informatica6.1 and infomatica7.1

TCS,

1242

can we use union transformation in joiner transformation?how?

Dabur, Tech Mahindra,

1 6512

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

CTS,

3 6646

how to through logic of informatica using the push down optimization into oracle.

Hexaware,

2 5442

Is there any model difference between ODS and DWH

Zensar,

2 4779

How You Pull the records on daily basis into your ETL Server.

TCS,

2 4852

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

Mphasis,

2 12606

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

Zensar,

2 4756


Post New Informatica Questions






Un-Answered Questions { Informatica }

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

168


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

150


What is different between the data warehouse and data mart?

191


What is the difference between a connected look up and unconnected lookup?

155


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

200






Where can we find the throughput option in informatica?

166


What is an unconnected transformation?

168


What is a surrogate key?

144


What do you mean by blocking transformation?

156


What are the static cache and dynamic cache in informatica?

158


How many number of sessions can one group in batches?

181


What are multi-group transformations?

174


Explian the connected and unconnected lookup transformation

193


What is depict expression change?

148


update strategy transformation in informatica

182