What are junk dimensions?
No Answer is Posted For this Question
Be the First to Post Answer
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
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?/
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?
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
any body can say about all versions of informatica ?how many versions ?
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.
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
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to call shell scripts from informatica?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
Which kind of index is preferred in DWH?
What is the reusable transformation?