Interested to Buy Any Domain ? << Click Here >> for more details...
in u flatfile some of fact records are missed then u load
the diminision records are not if u load diminsion records
what about fact table records
- 0 Answers
- 2203 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Target increases every day even though no new record was inserted
Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
What do you mean incremental aggregation?
How can we update a record in the target table without using update strategy?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
what is the need of session partitioning... how it is useful in real time
What is the procedure for creating independent data marts from informatica 7.1?
How to load time dimension?
in performance wise union is past,union all is past
what is mapping override?
How do you load only null records into target?
Teradata 
