What is the default source option for update stratgey
transformation?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
can we use mapplet as starting n ending object in mapping
If I am having 6 flat files in data. How can you load the data at a time
how to create user defined function (udf) in informatica
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
How the dimensions will be loaded?
Briefly define a session task?
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
Is snow flake or star schema used? If star schema means why?
What you know about transaction control transformation?