Informatica interview questions – page 3

What are limitations of joiner transformation?

If there are 3 workflows are running and if 1st workflowfails then how could we start 2nd workflow or if 2ndworkflow fails how could we start 3rd workflow?

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

What is the use of "Usage" field in the item categorydetermination? please any one kindly give me the answer?

What is data driven in update strategy transformation?

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

Are there any types of Dynamic Caches in informatica

I have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

Difference between informatica 8.6 and 9

What is diff joiner and lookup

How could we generate the sequence of key values without using sequence generator transformation in the target ?

What is the necessity to use update strategy?(except forupdates)

Difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

How do u decide whether u need to do aggregations atdatabase level or at Informatica level?

What is use of batch file in informatica? How many types of batch file in informatica?

Can we write to_date(three arguments) ? Will it work ? Advance thanks

How we can do session partition in informatica any one explain me clearly?.

What is diff between connected and unconnected lookup?

My source table having some records ,i want load 1st recordand last record into one target?

There is a mapping with expression and mapping we createsome condition for insert and update and followed by updatestartegy ,can we update and insert on a single target basedon condition?

Write a query row to column follwing source?quarter salesq1 5000q1 9000q1 7000q1 6000q2 5000q2 4000q2 3000q2 1000q3 4000q3 3000q3 1000q3 2000q4 5000q4 400 i want the output? q1 q2 q3 q4 sales

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

How to join the two flatfiles using the joiner t/r if thereis no matching port?

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

What r the type of indexes u generally used in informatica?

What are the output files that the informatica server creats during running a session?

I have n number of records in my source, i want first andlast record to my target. how can u implement this scenario .

By seeing the parameter file how do u identify wheather itis a workflow parameter or mapping parameter?

What is mapping parameter and mapping variables