Question { 6436 }

task is running successfully but data is not loded why?

Answer

There could be many possibilites:

1) Data are getting rejected due to primary key violation
2) The conditions given in filter or router or update are
satisfying.
3) Make sure 'Enable Test load' option is not enabled.
4) Check for any post sql override in the session
Properties.

Question { HSBC, 20086 }

if we r using aggregator we enabled sorted input but the
records r not sorted what happen?

Answer

When the 'Sorted Input' is enabled and if the data is not
sorted, then unexpected results will occur. It means the
session will succeed but the end result may not be the way
as per the business requirement.

Another point to be remembered is:

Group by columns in the Aggregator transformation must be
in the same order as they appear in the Sorter
transformation

Question { 16328 }

how will you remove the duplicate records from flat file
without using sorter?

Answer

We can use the option 'SELECT DISTINCT' in the source
qualifier.

Anybody please tell me whether this works or not.

Question { 18836 }

How to extract original records at one target & Duplicate
records at one target?

Answer

yes... add a new column in the sql override by calculating
the count(*) to get how many times the record is repeating.
Using Router we can seperate them into two different
targets.

Question { 24220 }

How to get EVEN & ODD numbers separately?

Answer

There are many ways....

1) Using the sql override in the source qualifier. To find
the even and odd. Add another column to flag the even and
odd.Like

select ID,decode( id/2,0,'E','O') FLAG FROM TABLE_NAME;

Using the router we can send them into two seperate target
tables.

Question { 9139 }

How to retrieve last two days updated records?

Answer

select * from date_Test
where dt between sysdate-2 and sysdate ;

Hope this works....
If not anyone please let me know...

Question { 17906 }

In a table, 4 person having same salary. How to get Third
person record only?

Answer

It can be retrieved with a simple subquery.

For example, I create a table sal with id,sal

id sal
-------
11 1000
22 1000
33 1000
44 1000

to retrieve the third column with the same salary
use the below query:

select id,sal from (select id,sal,rownum r from sal)
where r=3;

Question { iFlex, 10706 }

if i have records like these
(source table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
10001 gfhgdgh
10002 hjkdghkfh

the target table should be like these by using expression
tranformation.
(Target table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
xx001 gfhgdgh
xx002 hjkdghkfh
(that means duplicated records should contain XX in there
rowid)

Answer

First make sure the values are sorted by rowid and passed
to an expression transformaion.Now create a variable port
in the exp. Lets think var1 and make it empty in the
expression .

now compare rowid with var1 by

IIF(VAR1=ROWID,XX||SUBSTR(ROWID,3,3),ROWID)

When the session starts, since initially the var1 is null,
it will be replaced with first rowid. When the second
record is passed, the values will match the required format
of rowid will be passed and remember to pass the value in
the var1 to the next transformation or target.

Hope this will solve.
Please let me if anything is wrong or does not work out.

Question { HP, 7023 }

What are the challenges of Dataware housing in the future?

Answer

I think as we move into the future, the historical data
size increases which impacts the performace for complex
calculations or aggregations. Which also impacts at report
level to drill down.