what is hash table in informatica?
- 1 Answers
- 7277 Views
- Zensar, I also Faced
- E-Mail Answers
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 |
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
What are the diffrences between joiner transformation and source qualifier transformation?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
Explain the types of lookup transformation?
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek
How can we use mapping variables in informatica? Where do we use them?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
what is unit testing?tell me proceedure
What is the main difference between a Joiner Transformation and Union Transformation?
Teradata 
