exit interview questions
Transformation to Load 5 Flat files
What is the method of loading 5 flat files of having same structure to a single target and which transformations will you use?
PreSql in Source Qualifier and PreSQL in Target in Informatica
I am not able to understand the different between PreSql in Source Qualifier and PreSQL in Target in Informatica. I read many other posts they told pre SQL means ” SQL statement executed using the source connection,before a pipeline is run” and post SQL means ” SQL statement executed using the source connection,after a pipeline is run”. So if all PRESQL run at same point so why we have different PRESQL like PreSQL in SOurce qualifier and PreSQL in Target
Create Session log as a Parameter in Informatica Cloud
How to create a session log as a parameter in informatica cloud?
what are the daily routines of an informatica developer?
If I have a source as below:
Employeed, FamilyId, Contribution
And my desired target is as below:
Explanation: The contribution field in target is the individual Employee’s share in a family’s contribution.Say if total family contribution is 40000 then if A has contributed 10000 then target should have a value of 25%.
Can you please suggest me an approach to solve the specified problem?
pivoting of the records
source: target: col1 col2 col1 col2 a 1 1 a,b,c,d b 1 2 p,q,r c 1 3 x d 1 p 2 q 2 r 2 x 3 how to do this. Thanks, krishna.
What are the types of loading in Informatica?
Filter, Sorter, Joiner Transformations and Source Qualifier
Why do we need transformations like filter, sorter, Joiner etc when we can do all those tasks with Source Qualifier itself using queries?
what is rank transformation?where can we use this transformation?
How to remove footer from flat file source
Flat File as Source in Informatica
How can we receive source as flat file in informatica, from where we get this flat file?
Is it possible to use SCD Type-2 without using Lookup in the mapping?If it is possible please let me know. How it will be possible?
Add/Modify Column Changes in Facts and Dimensions
How often do you get Add/modify column changes in Facts and dimensions? Could you please give me couple real time Datawarehouse Project specific (Day to day work) scenarios?
Execute Workflows Conditionally
I have 2 workflows named as W1 and W2 so I need to execute W2 but after W1 workflow executed successfully then only executed W2 workflow? How to do this one?
how many types of sessions are there in informatica.please explain them.
What is use of UNIX in Informatica?
What is use of UNIX in Informatica? Where and how can we use UNIX shell scripts or commands to run informatica jobs or other related applications in informatica?
Why cant we use a sequence generator or update strategy transformation before a joiner or union transformation?
Informatica High Availability check
How to check if the Informatica Power Center is highly available?
What is the default join that source qualifier provides?
Inner equi join.
Check Manual Entries in Target Table
I am loading records from a source table to a CRM target table. I want to get the details of the manually inserted, updated, deleted records from the target table. Please explain in detail.