Informatica Interview Questions
Questions Answers Views Company eMail

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1616

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 11273

What is the main difference between a Joiner Transformation and Union Transformation?

5 29940

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1457

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

Wipro,

1 2882

4 yrs etl devloper roles and responsibilities?any body give solutions

TCS,

1564

difference between informatica 8.1.1 and 8.6

TCS,

3236

draw informatica architecture 8.6 ?

Cognizant, TCS,

3466

complex mapping ur project u r invlve can u explain and give real time example give me ?

HGS, TCS,

1833

how to run workflow in unix?

Colgate, HP, Tech Mahindra,

5 22760

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

IBM,

9156

when informatica 8 series released ?

IBM,

1 3467

what is meant by data driven.. in which scenario we use that..?

IBM,

2 5335

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?

1446

WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 4000


Post New Informatica Questions

Un-Answered Questions { Informatica }

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3313


Differentiate between Load Manager and DTM?

1656


What is the difference between informatics 7x and 8x and what is latest version?

538


What is the use of an aggregator cache file?

681


What is xml source qualifier transformation in informatica?

709






What is an expression transformation in informatica?

514


Can we create a node as a gateway node and the same node can be assigned to a grid?

635


What is a joiner transformation and why it is an active one?

570


r u done any partitions in ur project?

1397


What is a shortcut and copy in Informatica and how two are different with each other?

670


What does reusable transformation mean?

667


How might you approve all mappings in the archive all the while?

596


How to improve the performance of a session using sorter transformation?

682


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

548


What are the different versions of informatica?

670