hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
3 6978How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
AHM,
2 6575Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
TCS,
2 8941S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
TCS,
5 14562if we r using aggregator we enabled sorted input but the records r not sorted what happen?
HSBC,
7 22132Post New Informatica Questions
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?
Why do we need informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are data-driven sessions?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
what is the size of your data warehousing?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the issues you have faced in your project? How did you overcome those issues?
Repository user profiles
Define joiner transformation?
What are the different transaction levels available in transaction control transformation?
What is a snowflake schema?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the static cache and dynamic cache in informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?