How can we use batches?
No Answer is Posted For this Question
Be the First to Post Answer
Enlist the advantages of informatica.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
tell me 7.x and 8.x diferrencess(but not transformations)
Useful UNIX commands regular/frequently used
where actually the usage of push down optimization happens...
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
Describe the impact of several join conditions and join order in a joiner transformation?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
Why use the lookup transformation ?