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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

write a query following source
region sales
1 1000
2 2000
i want the output ?please give solution
1 2
1000 2000

Question Posted / santosh kumar sarangi

Answer Posted / santosh kumar sarangi

Its not possible to create a table with number as column name.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different lookup methods used in informatica?

973

Explain in detail about scd type 1 through mapping.

1298

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1057

Under which circumstances, informatica server creates reject files?

1026

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10630

Why filter transformation is an active one?

929

What is dimensional table?

1002

What is the difference between router and filter?

1153

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1220

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2053

Differentiate between source qualifier and filter transformation?

1509

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1842

What are the mapping parameters and mapping variables?

1087

Which are the different editions of informatica powercenter that are available?

971

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

7872