Informatica Interview Questions
Questions Answers Views Company eMail

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 1940

Have you worked with/created Parameter file

1219

What's the layout of parameter file (what does a parameter file contain?)?

Cognizant,

1905

Why do you use Mapping Parameter and mapping variable?

1270

Where do you create/define mapping parameter and mapping variable?

1 2603

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

IBM,

1 3067

Slowly changing dimensions, types and where will you use them

1260

What are the modules in Power Center

1216

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 4334

Parameter and variable differences

1608

Reusable transformation and shortcut differences

1365

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 1791

Implementation methodology

1249

Do you have knowledge in ralph kimball methodology

1 2720

According to his methodology what all you need before you build a datawarehouse

1179


Post New Informatica Questions

Un-Answered Questions { Informatica }

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1036


What is the function of aggregator transformation?

568


What is update strategy transform?

558


How do you migrate data from one environment to another?

634


What is the need of etl tools?

592






Have you worked with/created Parameter file

1219


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1483


How many numbers of sessions can one group in batches?

607


What is Index Caches size?

605


What are the different transaction levels available in transaction control transformation?

669


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

589


what is informatica metadata?

587


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1858


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

610


What is meant by LDAP users?

684