Does ideal Transformer transfer DC input voltage to secondary side, under NO-Load and Loaded condition?
It depends what you deem to be an ideal transformer.

If the ideal transformer has infinite primary inductance, no saturation, and no primary resistance, then it can carry an arbitrary primary current, and indeed a primary voltage will create a secondary voltage. A secondary load will then cause a secondary and primary current to flow.

If the ideal transformer has no resistance, but a finite inductance and a finite saturation current, then eventually saturation will stop the transformer working.