In a Flat File source there r Null as well as Blank values .If u r doing the profiling for that source ,how do u gete counts for the Null and Blank separately instead of getting them as one countThanksManish
Latest Answer : Create a dummy mapping with dummy as source and target column. Then create a session corresponding to this mapping. In the session go to tab Mapping.Then select the source in task type. In connections give the appropriate connection where you created ...
I am new to the informatica ..Can anyone explain stored procedure,sequence generator and lookup transformation with example...
I have a datatype as varchar2 in source table and when I load the data in the target table it is mapped to nclob datatype.when I run the mapping , there are junk values in my target table which has nclob datatype.Could you please let me know how to solve the issue.Thanks in advance
Hi All,I am loading a flat file into a DB2 database.My Session is succeeded but i am getting an error like this""WRITER_1_*_1> WRT_8229 Database errors occurred: FnName: Bind Parameter -- [Striva ][ODBC DETAIL Driver] DTL-00264 DBAPI Error. DB_DESCRIBE failed for file TCCCATCN.;DTL-01252 DBNTC Initial OPEN CONVERSE failed to location "SYSD", rcs 0/2014/-204.;DTL-02006 SQL prepare error. SQLCODE = -204.; DSNT408I SQLCODE = -204, ERROR: AVIPB.TCCCATCN IS AN UNDEFINED NAME; DSNT418I
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 ...
My Business case is to develop a informatica mapping for a Stored Procedurei have a cursor in a SP which has 5 tables in 'from' .. with some where conditions. how to develop mapping and fetch all the values
Latest Answer : We can get multiple values from unconnected lookup return port using conncatination logic, then we have to split the values to respect columns Do you need more information call 9833705604venu adavelly ...