how do u implement scheduling in Informatica?
Answer Posted / guest
use the scheduling options in the informatica or use pmcmd
commands
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can u access a repository created in previous version of Informatica?
Define slowly changing dimensions (SCD)?
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
Explain what are the various etl tools in the market?
what is different between sequential batch and concurrent batch and which is recommended and why?
what is pmrep command?
what are the concerns of OLTP and DSS systems?
how do u handle performance issues in Informatica . where can u monitor the performance ?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
How to delete data which is not in source table?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What is the difference between round-robin partitioning and hash partitioning?
How to fine tune mappings?
Do we need an ETL tool? When do we go for the tools in the market?
what is the meant by Normalization and de-normalization?