which one is better either active or passive transformation
in informatica
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
Can we create two repositories on same database instance in oracle?
how to calculate the optimum cache size in aggregator transformation?
Can we use parameters of parameter file in presession command
what is junk dimension
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
scenario where i can use only concurrent execution of workflow.
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
What is data merging, data cleansing and sampling?
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
What is active and passive transformation?
In development project what is the process to follow for an etl developer from day1