-
HAVING Clause
Given a SELECT statement that has a GROUP BY clause.The HAVING clause uses the same syntax as which other clause?A. WHEREB. UNIONC. SUBQUERYD. ORDER BY
-
Behaviour of Component in Differnt Version
How will you ensure that the components created in one version do not malfunction/cease functioning in other version?
-
Force_error Function
How does force_error function work ? If we set never abort in reformat , will force_error stop the graph or will it continue to process the next set of records ?
-
Phase verses Checkpoint
Difference between a phase and checkpoint as far as i know it something related with how temporary files containing the data landed to disk is handled.that is phases are used to break up a graph so that it does not use up all the memory , it reduce the no of component running in parallel hence improves the performances (used for performance fine tuning, by managing the resource in perfect manner)Check...
-
Parametrization of MFS
I want to use an Ab Initio parameter to control whether I am in serial or MFS mode. Basically, I will have an $AI_MFS_PARTS variable. If it is set to 1, then we are running serial. If it is set to 4, then we are running 4-way MFS. Will the data need to be located in physically different locations using different control files?
-
Cummulative summary in AB Initio
How can I achieve cummulative sumary in AB Initio other than using SCAN component. Is there any inbuilt function available for that?
-
Abinitio EME
In my sandbox i am having 10 graphs, i checked-in those graphs into EME. Again i checked-out the graph and i do the modifications, i found out the modifications was wrong. what i have to do if i want to get the original graph..?
-
Abinitio Display records between 50-75..
In input dataset i am having 100 records. I want records between 50-75 and i don't want to read 5th record? which component i have to use..
-
Abinitio Merge Graphs
How do we merge graphs in AbInitio?
-
Abinitio Lookup
Can we process 1 GB data(1 million records) by using Lookup? How
-
-
-
-
-
-
Why go for sort within groups?
We have sort and sort within groups components. we can achieve the sort within group functionality by placing two keys in sort group. Then why we have to go for sort within groups?