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

How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 3564

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

IBM,

6 9089

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

TCS,

1585

Can we insert and update a target table without using update strategy transformation?How?

Syntel,

4 19733

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

Syntel,

3 7211

Can anyone tell me the new features in Informatica 9 Version?

Syntel,

1362

Can anyone tell me the new features in Informatica 9 Version?

Syntel,

2 6697

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

Syntel,

3 12234

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

Accenture,

2 5798

Is there any target staging area in informatica not staging area

Syntel,

1934

How to fix the etl bugs..Tell me the process?

IBM,

1 2591

why we are using level option in normalizer transformation

TCS, Wells Fargo,

6046

what is data driven?

1 2982

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

TCS,

4 6360

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

HTC, TCS,

1 7533


Post New Informatica Questions

Un-Answered Questions { Informatica }

In informatics server which files are created during the session rums?

477


What is dimensional table? Explain the different dimensions.

417


What are mapplets?

603


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5142


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

455






Can u generate reports in Informatica?

508


What are Dimensional table?

456


Explain in detail about scd type 1 through mapping.

412


What can we do to improve the performance of informatica aggregator transformation?

449


What is sorter transformation?

416


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 ?

1741


What are the reusable transformations?

528


Explain the features of connected and unconnected lookup.

379


What are the databases that informatica can connect to windows?

437


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1437