Datastage tricky questions
1) Aggregator - Is Sort needed - Only when the method is defined as Sort. If defined as Hash, no so…
1) Aggregator - Is Sort needed - Only when the method is defined as Sort. If defined as Hash, no so…
Taken from http://victimizeit.blogspot.in/2012/07/xmeta-db-datastage-repository.html XMeta DB : …
Taken from - http://www.rahul.net/raithel/MyBackPages/crontab.html The Linux utilities cron and…
It is possible to set or copy job specific environment variables directly to the DSParams file in …
Sed and Awk behave in a similar way to a large extent - the obvious question then arises as to when…
Handy list of awk one liners taken from http://www.pement.org/awk/awk1line.txt USAGE: Unix:…
Very useful list of sed one liners taken from http://sed.sourceforge.net/sed1line.txt FILE SPAC…
The previous post on grep one-liners just had the synatx, so could be a little confusing.. Here I…
There are useful grep one liners taken from the blog - http://girirajcollections.blogspot.in/2010…
Few are listed here taken from it-toolbox - will be listing more in later posts.... http://it.too…
Partition by is used while writing the analytical functions in Oracle. Referring to this blog - h…
A very common question in interviews is regarding SQL optimization - Am copying the optimization …
Indexes are created on database tables for effective joins. But what if too many indexes are create…
1) Define Datastage 8.1 runtime architecture. 2) Define Conductor Node, Section Leader and Players.…
1) What kind of Cardinality exists between Fact and Dimension tables? 2) Bridge tables - Do we need…
1) Difference between Identity Column and Sequences. 2) Difference between bulk load and normal load…
1) What is the output of rtrim('hello',a)? 2) Which System table shows the Last modified/com…
1) Can constraints be created through an application program? 2) Execution priority for Triggers, Co…
1) What are triggers? 2) What are constraints? 3) What is an Instead of Trigger? 4) Can a DBMS with …
1) What is SuperKey? 2) What is Dormant Entity? 3) Hierarchical Vs Relational Model 4) Codd's ru…
1) Difference between physical and logical database structures. 2) What are Candidate Keys? 3) What …
Recently, I attended an interview for an ETL Senior developer role and was asked to appear for two o…
Records are duplicated in the job (even if the flow is not duplicated in datastage!). Cause - It wa…
Batch job (job control script) was migrated from one environment to another. On the new environment,…
A field, XXX_ID is not extracted the right way. Example: we should get XXX_ID = B0061 but we got B00…
Set the Environment Variable DS_ENABLE_RESERVED_CHAR_CONVERT to TRUE. It is necessary to read reserv…
Error: FTP_ENTREPRISE,0: Error from input record streamer. You need to set the Record Delimiter Prop…
main_program: Fatal Error: There are irreconcilable constraints on the number ofpartitions of an ope…
The type money exists in SQL Server. It is like an Integer divided by 1000. So it is equivalent to D…
A lookup could generate new lines (like a left join), how is that possible? I thought that a lookup …
A warning on Transformation job on the import of a special character. APT_CombinedOperatorController…
There is a field which finishes with a CR character (/n). Following options were tried, but didn'…
A value in the database is '‘MODU¿7,5’ But when we tried to retrieve this value through the Ora…
This is one of the problems we faced while using ODBC Stage in DS 8.1. We used to define the 'Tr…