What are junk dimensions?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,


i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,


in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

2 Answers   Thomson Reuters,


wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  


any body can say about all versions of informatica ?how many versions ?

2 Answers  






1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers  


What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,


Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  


How to call shell scripts from informatica?

0 Answers  


In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,


Which kind of index is preferred in DWH?

3 Answers  


What is the reusable transformation?

0 Answers  


Categories