when u connect the repository for the first time it asks you
for user name & password of repository and database both.But
subsequent times it asks only repository password. why?
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)
How to Check the source record count from traget table.
When do we analyze the tables? How do we do it?
how do u extract data from different data sources explain with an example?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
what is the difference between normal & bulk loading? and which one is recommended ? why?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
how to connect to a flatfile through ftp in informatica
Do we need an ETL tool? When do we go for the tools in the market?
Eliminating of duplicate records without using dynamic lookups
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks