what is hash table in informatica?
Answer / pooja
In hash partitioning, the Informatica Server uses a hash function to group rows of data among partitions. The Informatica Server groups the data based on a partition key. Use hash partitioning when you want the Informatica Server to distribute rows to the partitions by group
Is This Answer Correct ? | 0 Yes | 0 No |
diffrence between command task and control task
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
what is the function of 'F10' informatica ?
While importing the relational source defintion from database,what are the meta data of source U import?
What are the Differences between connected and unconnected lookup?
How many ways a relational source definition can be updated and what are they?
What is a command that used to run a batch?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
What are ETL Tools?
whats the logic to load the lower level of granularity of data to fact table.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?