Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

chandrasekar


{ City } chennai
< Country > india
* Profession *
User No # 72801
Total Questions Posted # 5
Total Answers Posted # 37

Total Answers Posted for My Questions # 12
Total Views for My Questions # 57563

Users Marked my Answers as Correct # 109
Users Marked my Answers as Wrong # 25
Answers / { chandrasekar }

Question { CTS, 6788 }

normalizer transformation


Answer

Normalizer transformation is an active. It is used to import
the cobol sources. The cobol source is associated with
normalizer transformation.

It is used to single input record to multiple record is
known as data pivot.

Is This Answer Correct ?    3 Yes 0 No

Question { 10591 }

what is mean by flag 4 in update strategy t/r


Answer

I think Flag 4 means DD_REJECT. It wont send any records to
target.

If i wrong means please mail me at chandranmca2007@gmail.com

Is This Answer Correct ?    3 Yes 5 No


Question { Puma, 10051 }

How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)


Answer

First we can count the no of records using aggregator
Transformation with group by (port) for ex, in emp table
take empno. Second we can take the Filter condition like
count=1. Other records are rejected not loaded into the target.

Hope it will help little bit...

Is This Answer Correct ?    1 Yes 1 No

Question { 6118 }

how to get the only updated records in the target


Answer

Using unconnected lookup

Is This Answer Correct ?    0 Yes 1 No

Question { IBM, 8037 }

Does Facttable Normalized or Denormalized?


Answer

Fact tables are normalized. Dimension tables are denormalized

Is This Answer Correct ?    27 Yes 0 No

Question { IBM, 8858 }

why we use stored procedure transformation?


Answer

The Stored Procedure Transformation is used to call the
stored procedure.

First, we have to create a Stored procedure in Oracle or SQL
Server.It have 2 types.

one is Connected Stored Procedure and another one is
Unconnected Stored Procedure.

Is This Answer Correct ?    5 Yes 0 No

Question { 6003 }

what is distinct


Answer

DISTINCT is used to display the unique records.

Is This Answer Correct ?    5 Yes 0 No

Prev    1   2    [3]