if flat files is your source. what are the option in session to take bulk of files from same folder have the same structure of all the files..
Latest Answer: For that you can select source file type as indirect and you have to specify that folder path at source file directory. ...
Latest Answer: i think you can write the sql query (delete from....) in session post-sql command and it will work good. ...
Latest Answer: 1st u have to check the source file name,target file name that u set in Session edit being present in the unix server or not.If not present by applying the CP command:-make copy from one file to other.Regards,Dichen Kumar Mishra ...
Hi,Can Informatica power center 7.1.1 installed on Windows vista home premium? If so how to install informatica server and repository server?Thank you,Vamshi.
Latest Answer: but i could not find an option windows xp service pack 2 after right clicking on setup.exe of informatica powercenter 7.1.1, still the error is continuing if i try to execute setup.exe ...can anyone come up with the solution ...
Latest Answer: Direct mode means when you are loading a flat file. Indirect mode means when you are loading list of files having same property. ...
I have two variable ports v1 and v2; v2 is calculated based on v1. What will be the value of v2 for the first time, if the order of ports evaluation is v2 and v1
Write a query to retrieve latest records from the target table means if we have used scd2 version type of dimension, than retrieve the record with highest version no.for eg verno id loc 1 100 bang 2 100 kol 1 101 bang 2 101 chenwe have to retrieve 100/kol and 101/chen. how it is possible through query.
Could anyone let me know a scenario in telecom project where he developed a complex mapping with solution. please do let me know the transformation details also.
Hi frnds, let me know the solution for this. i have emp table with eno, ename as columns with duplicate rows.Ex : eno ename 1 kiran 2 sena 3 naveen 1 kiran 4 dev 3 naveen 1 kiran 5 loki 3 naveen 1 kiran 6 shashi 1 kiran etc... so iwant to find out the third occurance
Can anyone tell me how to create time dimension? Do we have to use type1,2,or3 for creating time dimension or we can just create it by using only expression transf and a date column from the source?Thanks in advance.
View page << Previous 14 15 16 17 [18] 19 20 21 22 23 Next >>
Go Top
