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 have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 3820

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 5220

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 7464

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 8459

. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 4537

what is threshold error in informatica?

TCS, Wipro,

1 16659

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

Wipro,

11 16824

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

Wipro,

2 5929

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

Wipro,

1 6172

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

HCL, Schneider,

6 14162

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

IBM, TCS,

6 11668

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

CTS,

1220

How to do Integration testing in Informatica?

Intelligroup,

5 9559

There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 6074

What is the Difference between sorter and aggregator?

2 6666


Post New Informatica Questions






Un-Answered Questions { Informatica }

Why is sorter an active transformation?

177


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1087


what is mean by complex business rule ?

1170


 Informatica Checkpoints

2393


Explain the tuning lookup transformation - informatica

172






On which transformations you created partitions in your project?

317


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1039


Do you find any difficulty while working with flat files as source and target?

189


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

150


Write the unconnected lookup syntax?

147


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

137


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1480


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

175


Explain sql transformation in script mode examples in informatica

181


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1210