Explain pushdown optimization $pushdownconfig parameter - informatica
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
What is a data modeling?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
what is the use of Data Mart?
Which are the different editions of informatica powercenter that are available?
what is lookup chache?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
How many repositories can be created in informatica?