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)
CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE
REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER?
AND DEFERENCIATE THESE TWO ?
1). REPORT PROCEDURE
2). TABULATE PROCEDURE
Hi Friends,
I want lo truncate my records from target before loading
current month data,but i dont have permission to truncate
with truncate option
if u know any other way please give your valuable input for
this.
Thanks
Abhishek
How can we convert crystal dictionary dc5 file to another
datasource format like mdb or xml schema ?
29
Explain clustering algorithm?
54
What are the components new in 2.14 compared to 1.8 and
State the usage of the components?
46
1.How is "Query drill" mode different from standard drill
mode?.
2.Under what circumstances are you most likely to choose to
use "Query drill" mode instead of standard query mode?.
3.How do you implement the type2 slowly changing dimensions
in your project?.
4.what is meant by Junk dimension?.
5.what is meant by Drill across?.
28
What is the disadvantages of using Database functions
instead of using Cognos Functions in Report studio?
in single column there is india and malaysia and uk canada
and dubai,saudi.ok i need using valuable prompt i select
asian country will be display india malaysia and i will
select eurobe country only display uk canada.pls tell me
any how do set this concept using valuable prompt
24
what is the difference between cardinality and Nullability?
21
Give e an example of..
36
How a Referential integrity is handled in Teradata?
5
how do u estimate the number of partitions that a mapping
really requires? Is it dependent on the machine configuration?
Site Map