If you concatenate data from a normalizer
transformation,the ports you concatenate cannot include
OCCURS(T/F).
when should one create lookup transformation ?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
how do u set the size of block buffer?
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
SCD2 will work on only dimension tables as well as fact Table?
what is the difference steps for data modeling?
how do u really know that paging to disk is happening while u are using a lookup transform?
When do we analyze the tables? How do we do it?
What is grain of fact?