Most of my company uses powercenter informatica for Extract-Transform-Load type data move jobs between databases. However project I am on has a big custom Perl job with some Java thrown in for good measure to move data and trigger some other updates. There is talk of rewriting the thing to use powercenter instead, what are people's e...
Duplicate: http://stackoverflow.com/questions/1259545/let-me-know-alternate-command-in-dos-for-following-sed-and-perl-commands-closed the following commands have unique implementation in unix box. Need to implement in informatica(etl tool). If not any windows solution for the same sed 's/^#//g' < kam_account_calls.txt > kam_account_...
Hi, I have source column(amount) with datatype string, contains the datas like $793.00, $5791.00,... I need to load this same data into the target table column(amount) with datatype NUMBER how can i get this same data with '$' symbol in target by using expression transformation in informatica? anyone help me please, thanks in advance...
I have two sources (source A and Source B), source B is an another one target table in my db. both are in diff user id . Now i have to transfer some data,s from these two sources to target table. Can i transfer data without using the joiner transfermation? how to do ? ...
I want to know how to rename the ODBC data source in informatica. ...
I am loading data from a flat file to table using informatica, the file has both english and foreign language characters like chinese, and others. The foreign language characters are not getting displayed properly after loading. How can this problem be solved ? I could solve it by using code page UTF - 16 Encoding of Unicode Platform End...
I have to load the target table copy of data into the text file at the time of workflow running.(i.e)Whatever data are going into the the target table that should come into the text file also. ...
I want to copy the data into one excel file, while the mapping has been running in informatica. ...
i want to devlop a mapping for followinfg scenerio . I have a 1 source and 1 target and 1 error table.Target and Error tables have all fields that are present in source tables.But the data type o of all fieds for error table are varchar .Error table dont have integirty or foreign key and other constraints . Error table also have2 more f...
In the past, I have used Informatica for some ETL (Extraction Transformation Loading) but found it rather slow and usually replaced it with some PL/SQL scripts (was using Oracle at the time). (questions revised based on feedback in answers) I gather that DTS was Microsoft's ETL tool prior to SSIS. Would it be difficult to convert an ...
Hi, I am facing the error "This represents an internal error at the Informatica PowerCenter Web Services Hub. error code is : WSH_95000" while access the informatica web services methods.I am able to login and able to get the sessionid provided by the login response. I am passing the same session id for every SOAP call. But able to initi...
I need some information about the Informatica ETL tool. I am a rookie with that, so could you please recommend where can I get some tutorials to get started. Can I download the tool, and if so where can I download it? What are the alternatives to Informatica? ...
Hi All, Please tell the concept of AbInitio recovery file. When the Abinitio graph fails in execution which cases should we rollback the recovery file and in which cases we shouldnt rollback the recovery file. Please provide links for any AbInitio materials. Thanks. ...
"The installer cannot ping the domain.Verify that Informatica Services is running on the domain host and select Retry. STDOUT: [1212] Command [ping] failed with error [[2121] Node [raskart] Domain [Doraskart] Host:Port [Doraskart:6001] has failed to ping back.]. exitcode -1 " This error occured when i tried to install informatica in my...
Hi, we are trying to run one session which is pointing to large mapping, it has many conversions. In this mapping we are doing conversion like lpad(SUP,7,0)||'0'||lpad(ITEM,7,0) for joining with other port. Here we didnt get any error while validating the mapping. But while running the session, some times we r getting the error 'trans...
Hi, Is there any function to replace the special characters by null in informatica if we used replacestr function, i think we should specify all special characters as follows replacestr(input,'!','~','@','#','$','%','^','&','*',null) But we dont know what are teh special characters will be coming as input. can u please let me know ...
Hi, Is there any function to replace the special characters by null in informatica if we used replacestr function, i think we should specify all special characters as follows replacestr(input,'!','~','@','#','$','%','^','&','*',null) But we dont know what are teh special characters will be coming as input. can u please let me know ...
Why doesn't Informatica's joiner transformation support !=, >=, <= operators? Why should they come up with a concept like lookup? ...
Hi! I have two tables to join with a column (say emp_id).. if emp_id in both the tables have null values, how will SQL Server and Oracle treat??? Coz, I read that informatica will neglect the NULL rows when joining..if I handle the null, by substituting -1, a cross-join will happen which i don't want.. What can I do here? I cannot co...
I have a Informatica session which is linked to a wrong mapping. How do i change the mapping from M1 to M2 in the same session S1 and Workflow W1 WITHOUT importing/exporting as XML and making the changes ??? ...