 Related Questions a)Star Schema - Simple & Much Faster. Denormalized form. b)Snowflake Schema - Complex with more Granularity. More normalized form. Latest Answer : Is not star schema better performance wise (querying) as it has less no of join due to denormalized structure? Please clarify ... We use a) "Iconv" function - Internal Convertion. b) "Oconv" function - External Convertion. Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-MDY[2,2,4]") Latest Answer : we can achieve this conversion using transformer stage conversion functions in PX.Hanu. ... Yes, We can convert by attaching one hierarchy to lowest level of another hierarchy. Latest Answer : No. It is not possible ... Read Answers (1) | Asked by : dwandbi Latest Answer : Hi,I have worked on server to px migration project. you can't directly convert a server job to PX job. the only way is, you have to redevelop the px job using px environment.Regards,Veeru. ... Tags : Parallel Server 1 1. Difference between Hashfile and Sequential File?. What is modulus?2 2. What is iconv and oconv functions?.3 3. How can we join one Oracle source and Sequential file?.4 4. How can we implement Slowly Changing Dimensions in DataStage?.5 5. How can we implement Lookup in DataStage Server jobs?.6 6. What are all the third party tools used in DataStage?.7 7. what is the difference between routine and transform and function?.8 8. what are the Job parameters?.9 9. Plug-in?.10 10.How can we improve Read Answers (1) | Asked by : Zias Latest Answer : There are 2 types of star schemas in datastage1.Starschema: A single fact table sits in middele and surounded dimension tables radically connect with fact table like a star. in star schema dimension tables are denormalized format. here few joins are enough ... Want to convert Char to timestamp in transformer stage. Can anybody please tell me what conversion function I need to put in derivation? View Question | Asked by : Sulogna 1. Is the Hash file is active or passive? If we take as source ?2. can u take seq file as look up?3. In hash file dynamic 30, there r two types:1)genaric2)specific what is the meaning?4. how to connect Latest Answer : 34th Question:By killing process id in server console we can release the job. ... What is Orchestrate Schema? Distinguish internal data type (Orchestrate schema) vs external data type
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
