1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
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 2581

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

 1527

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 2978

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

TCS,

2 3359

explain different levels in pushdown optimization with example?

TCS,

2 6428

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

CTS, TCS,

1825

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

 1244

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

TCS,

1703

can we use union transformation in joiner transformation?how?

Dabur, Tech Mahindra,

1 8014

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

CTS,

3 7909

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

Hexaware,

2 6714

Is there any model difference between ODS and DWH

Zensar,

2 6111

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

TCS,

2 5954

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

Mphasis,

2 13897

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 5861

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is source qualifier transformation in informatica?

562

Briefly explain the aggregator transformation?

582

Global and Local shortcuts. Advantages.

1453

What are the advantages of informatica?

562

Can we create a Integration service without a Repository service and vice versa?

718




What is the use of code page?

596

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

617

What are active transformations.

1179

Reusable transformation and shortcut differences

1365

What are the conditions needed to improve the performance of informatica aggregator transformation?

577

Name at least 5 different types of transformations used in mapping design and state the use of each.?

660

What does cheating measurement mean?

588

Is there any target staging area in informatica not staging area

2117

What are the various types of transformation?

636

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

715

For More Un-Answered { Informatica } Questions Click Here