DSXchange

We solved this problem in 7.5.2 by writing a build op that did the comparisons. Our requirement was given a set of data in the format of any number of keys|any number of data columns|row stats such as update date and update user, produce a row of data for each column changed based on keys. The produ...

Is there a way to rename a project without creating a new project and importing into it?

Thanks,

I found this article to be helpful in estimating development time for Datastage jobs.

http://blogs.ittoolbox.com/dw/soa/archi ... jobs-19406

So let me summarize and see if people agree or disagree. While general ETL, SQL and UNIX skills will transfer, specific Informatica skills may not and could be a hinderance. Therefore I should focus on candidates with strong general ETL, SQL and UNIX skills with the knowledge that I am going to have...

I am interviewing people for a couple of positions in our company and our recuiters are having a hard time finding people with Datastage skills. So we are concidering interviewing people with ETL and Informatica skills that have express an interest in learning Datastage. And while I feel comfortable...

Occasionally we will develop jobs that have a reporting component and various inserts into our database. We will create an environment variable "Insert Data" and default that to no. When the job is run with the Insert Data variable set to no only the reports are generated. When the job is ...

How about SELECT o_abc_uid + 0 FROM tablename... Hopefully the arithmetic will perform a legal implicit CAST. If we cast serial8 to integer, it works fine. But the problem is the integer datatype stores whole numbers that range from -2,147,483,647 to 2,147,483,647, for 9 or 10 digits of precision. ...